Create Dimension and Fact Tables in OLAP Database and Populate the Dimension and Fact Tables 11

Download the Sql File attached to the 

Run Script that is attached to Dimensions and Fact Tables in OLAP Database. Once ran the tables will be made up of these columns.




  

After creating the Dimensions and Fact tables in OLAP Database- Create a store procedure in the sql server to using Populate the Dim Date and Use SSIS Execute Task Flow to execute the store procedure to populate the Dimension Date table. Sql File attached to the for the Dim Date 




After creating the Dimensions and Fact tables in OLAP Database- use SSIS to populate the Dimension and Fact tables using the OLEDB_Source as source.  To load the clean data into the Data Warehouse tables - used Derived Column Transformation and Data Conversion Transformation    and Lookup Transformation to load the Dimension Tables into OLEDB_Destination.





To Load into Dim Agency



Look Up:


Look up1:



Derived Column:



OLEDB Command:





Repeat the same steps to load all the dimension tables. 


To Load Dim Employee:



Look Up:


Look up1:



Derived Column:



OLEDB Command:





To Load Dim LeaveStatus:



Look Up:


Look up1:


Derived Column:


OLEDB Command:



 

 


To Load Dim Job Status:


Look Up:


Look up1:


Derived Column:


OLEDB Command:





To Load Dim Title:


Look Up:


Look up1:

Derived Column:


OLEDB Command:





To Load Dim Location:


Look up:


Look up1:


Derived Column:


OLEDB Command:





After creating the Dimensions and Fact tables in OLAP Database- use SSIS to populate the Dimension and Fact tables using the OLEDB_Source as source.  To load the clean data into the Data Warehouse tables - used Derived Column Transformation and Data Conversion Transformation    and Lookup Transformation to load the Fact Tables into OLEDB_Destination.



Repeat the same steps to load all the Fact tables.



Execute the package to populate the Dimensions and Fact tables with the data.


The Dimensions and Fact tables is populated with Data.